USE NutritionTracker
GO
IF EXISTS (SELECT 1 FROM sysobjects WHERE ID = object_id(N'AppRole_Read_List') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
	DROP PROCEDURE AppRole_Read_List
GO
CREATE PROC AppRole_Read_List
AS
BEGIN
	SET NOCOUNT ON

	SELECT		AppRoleID,
			AppRoleName
	FROM		AppRole
	WHERE		Deleted = 0
	ORDER BY		AppRoleName
	
	SET NOCOUNT OFF
END
GO
GRANT EXECUTE ON AppRole_Read_List TO NUTRKR_WEB
GO
